You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
SPONDYLUS SWINNENI |
12.00 | |
TENGUELLA MARGINALBA |
3.00 | |
CERITHIUM GEMMATUM |
4.00 | |
TUTUFA TENUIGRANOSA |
8.00 | |
CHAMA LAZARUS |
12.00 | |
ARCHITECTONICA PERSPECTIVA |
5.00 | |
LYNCINA LEVIATHAN TITAN |
6.00 | |
NIOTHA GRUNERI |
3.00 | |
CONUS TEXTILE |
8.00 | |
LATIRUS RECURVIROSTRATUM |
12.00 | |
PINCTADA RADIATA |
15.00 | |
CONUS RETIFER SOLIDUS |
20.00 | |
CANARIUM RADIANS |
4.00 | |
CONUS MOLUCCENSIS |
25.00 | |
GAILLEA CANETAE |
50.00 | |
LIOPHOTOMA OLANGOENSIS |
8.00 | |
LYNCINA LEVIATHAN TITAN |
12.00 | |
EUGLANDINA TRUNCATA |
25.00 | |
VENERUPIS DECUSSATA DECUSSATA |
5.00 | |
MAURITIA ARABICA GIBBA |
50.00 | |
STROMBUS FRAGILIS |
6.00 | |
CONUS MOLUCCENSIS |
15.00 | |
PURPURA PERSICA |
8.00 | |
PUGILINA MORIO |
35.00 | |
CONUS QUERCINUS |
4.00 | |
MUREX LOEBBECKEI |
120.00 | |
AUSTRIELLA CORRUGATA |
4.00 | |
CONUS CHIANGI |
6.00 | |
CONUS RADIATUS |
8.00 | |
CALLIOSTOMA TICAONICA |
4.00 | |
MONETARIA MONETA |
4.00 | |
CHICOREUS STRIGATUS |
30.00 | |
PINCTADA RADIATA |
25.00 | |
PALMADUSTA LUTEA |
4.00 | |
CONUS GLADIATOR |
12.00 | |
BABELOMUREX CENTIMANUS |
20.00 | |
CONUS MOLUCCENSIS |
45.00 | |
CONUS RADIATUS |
4.00 | |
CONUS MITRATUS |
95.00 | |
Total: | 736.00 |